TcaplusDB OMS Console - Create a Distributed Index (Global Index)

1. Function Descriptions

For details, see Global Index ,

2. Steps

App Management - Table Management - Select the table to be indexed - Batch index.

Check the fields that need to be indexed to create global indexes.

3. Notations

1. The List table cannot create global indexes.
2. The maximum length of the string type allowed in the index is 256 bytes. If the maximum length is exceeded, it will be truncated.
3. Fields of binary type cannot be set as indexes.
4. Only after creating the index can newly added fields be indexed; If decreasing the index field, the app must stop the index query for the decreased field first.
5. During index query, it needs to limit the number of records returned according to the size of the Key. If limit mode is used for pagination query, the maximum number of records returned by a request is min(3000, 1 MB/key maximum size).
6. Creating or rebuilding an index, which involves synchronizing inventory data, can take a long time.

4. Related Documents

In addition to creating distributed indexes through the OMS console, users can also Create a Distributed Index by calling the WebService API. The WebService API is mainly used in scenarios where distributed indexes need to be created automatically through code.